using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Spread.Common.Features.Sample;
using FarPoint.Win.Spread;
using FarPoint.Win;
using Spread.Common.DataStore;
using FarPoint.Win.Spread.CellType;

namespace Spread.DataBinding
{
    public partial class HierarchicalViews : BaseSampleControl
    {
        private DataSet _dataSet = new DataSet();
        private List<Student> _studentData = new List<Student>();
        private string[] _subjects = new string[] { "Maths", "English", "Science", "History", "Hindi" };

        public HierarchicalViews()
        {
            InitializeComponent();
            Name = "Hierarchical Views";

            SetupDataSet();
            InitializeControls();
        }
        
        private void Spread_ChildViewCreated(object sender, ChildViewCreatedEventArgs e)
        {
            var childSheet = e.SheetView;
            for (int i = 0; i < childSheet.Columns.Count; i++)
                childSheet.Columns[i].Width = 120;

            childSheet.RowHeader.AutoText = HeaderAutoText.Blank;
            childSheet.RowHeader.DefaultStyle.Border = new EmptyBorder();
            childSheet.SheetCornerStyle.Border = new EmptyBorder();
            childSheet.ColumnHeader.DefaultStyle.Font = new Font("Veranda", 8, FontStyle.Italic);
            childSheet.ColumnHeader.DefaultStyle.HorizontalAlignment = CellHorizontalAlignment.Left;
            childSheet.ColumnHeader.Cells[0, 0, 0, childSheet.ColumnCount - 1].Border = new LineBorder(Color.LightGray, 1, false, true, true, false);

            if (childSheet.ParentRelationName == "Orders")
            {
                childSheet.Columns[0].Visible = false;
                childSheet.Columns[4].CellType = new PercentCellType();
            }
            else if (childSheet.ParentRelationName == "Performance")
                childSheet.Columns[1].Visible = false;
        }

        private void InitializeControls()
        {
            //Sheet-1 setup
            sheet1.SheetName = "Hierarchical Data Binding";
            sheet1.DataAutoSizeColumns = false;
            sheet1.DataSource = _dataSet;
            sheet1.SetColumnWidth(-1, 150);
            sheet1.SetRowHeight(-1, 25);
            sheet1.RowHeader.Columns[0].Width = 50;
            sheet1.ColumnHeader.Columns[1].Label = "Customer Name";
            sheet1.Cells[0, 0, sheet1.RowCount-1, sheet1.ColumnCount-1].Border = new LineBorder(Color.LightGray, 1, false, true, false, false);
            sheet1.ExpandRow(0, true);

            //Sheet-2 setup
            sheet2.SheetName = "Custom Object List Binding";
            sheet2.DataAutoSizeColumns = false;
            sheet2.Columns.Default.Width = 150;
            sheet2.Rows.Default.Height = 21;
            sheet2.DataSource = _studentData;
            sheet2.Columns[2].Visible = false;
            sheet2.RowHeader.Columns[0].Width = 50;
            sheet2.Cells[0, 0, sheet2.RowCount-1, sheet2.ColumnCount - 1].Border = new LineBorder(Color.LightGray, 1, false, true, false, false);
            sheet2.ExpandRow(0, true);
        }
        private void SetupDataSet()
        {
            var service = new DataService();
            var orders = service.AccessDataSource.GetDataFrom("Nwind.mdb", "Select Orders.OrderID, Customers.ContactName, Orders.OrderDate From Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID").Tables[0].Copy();
            var products = service.AccessDataSource.GetDataFrom("Nwind.mdb", "Select [Order Details].OrderID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount FROM [Order Details] INNER JOIN Products ON [Order Details].ProductID = Products.ProductID").Tables[0].Copy();

            orders.TableName = "Orders"; products.TableName = "Products";
            _dataSet.Tables.Add(orders);
            _dataSet.Tables.Add(products);

            _dataSet.Relations.Add("Orders", orders.Columns["OrderID"], products.Columns["OrderID"]);

            //Custom Object List Data Source
            var students = service.StudentDashboardDataSource.GetAllStudents();
            var rnd = new Random();
            foreach(var student in students)
            {
                var performance = new List<Marks>();
                for(int i = 0; i < _subjects.Length; i++)
                {
                    var score = new List<object>();
                    score.Add(new { Week1 = rnd.Next(10, 99), Week2 = rnd.Next(10, 99), Week3 = rnd.Next(10, 99), Week4 = rnd.Next(10, 99) });
                    performance.Add(new Marks { Subject = _subjects[i], Score = score });
                }
                _studentData.Add(new Student { StudentID = student.ID, Name = student.Name, Performance = performance });
            }
        }
        class Student
        {
            public int StudentID { get; set; }
            public string Name { get; set; }
            public List<Marks> Performance { get; set; }
        }
        class Marks
        {
            public string Subject { get; set; }
            public List<object> Score { get; set; }
        }
    }
}


//
//HierarchicalViews.Designer.cs
//


namespace Spread.DataBinding
{
    partial class HierarchicalViews
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.spread = new FarPoint.Win.Spread.FpSpread();
            this.sheet1 = new FarPoint.Win.Spread.SheetView();
            this.sheet2 = new FarPoint.Win.Spread.SheetView();
            this.pnlMain.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.spread)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sheet1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.sheet2)).BeginInit();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this.spread);
            // 
            // spread
            // 
            this.spread.Dock = System.Windows.Forms.DockStyle.Fill;
            this.spread.Location = new System.Drawing.Point(0, 0);
            this.spread.Name = "spread";
            this.spread.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
            this.sheet1,
            this.sheet2});
            this.spread.Size = new System.Drawing.Size(477, 487);
            this.spread.Skin = FarPoint.Win.Spread.DefaultSpreadSkins.Office2016White;
            this.spread.StatusBarVisible = true;
            this.spread.TabIndex = 0;
            this.spread.ChildViewCreated += new FarPoint.Win.Spread.ChildViewCreatedEventHandler(this.Spread_ChildViewCreated);
            // 
            // sheet1
            // 
            this.sheet1.Reset();
            this.sheet1.SheetName = "Sheet1";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // sheet2
            // 
            this.sheet2.Reset();
            this.sheet2.SheetName = "Sheet2";
            // Formulas and custom names must be loaded with R1C1 reference style
            this.sheet2.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this.sheet2.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // HierarchicalViews
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "HierarchicalViews";
            this.pnlMain.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.spread)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sheet1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.sheet2)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private FarPoint.Win.Spread.FpSpread spread;
        private FarPoint.Win.Spread.SheetView sheet1;
        private FarPoint.Win.Spread.SheetView sheet2;
    }
}
